EMT Practice Test

1. Question Content...

---

Question1: Bold means doing something that might cause short term pain, not just something that looks good in a marketing email.

Question2: In gathering requirements for DW/BI projects, begin with the data goals and strategies first.

Question3: Different types of product Master Data solutions include:

Question4: The IBM Data Governance Council model is organized around four key categories. Select the answer that is not a category.

Question5: Controlling data availability requires management of user entitlements and of structures that technically control access based on entitlements.

Question6: In an information management context, the short-term wins and goals often arise from the resolution of an identified problem.

Question7: A goal of data governance is to enable an organisation to manage its data as a liability.

Question8: The flow of data in a data integration solution does not have to be designed and documented.

Question9: Data Warehouse describes the operational extract, cleansing, transformation, control and load processes that maintain the data in a data warehouse.

Question10: ANSI 859 recommends taking into account the following criteria when determining which control level applies to a data asset:

Question11: Technical metadata describes details of the processing and accessing of data.

Question12: Class operations can be:

Question13: Normalisation is the process of applying rules in order to organise business complexity into stable data structures.

Question14: Change only requires change agents in special circumstances, especially when there is little to no adoption.

Question15: DBAs exclusively perform all the activities of data storage and operations.

Question16: Measuring the effects of change management on in five key areas including: Awareness of the need to change; Desire to participate and support the change; Knowledge about how to change; Ability to implement new skills and behaviors; and Reinforcement to keep the change in place.

Question17: A deliverable in the data security context diagram is the data security architecture.

Question18: Data governance program must contribute to the organization by identifying and delivering on specific benefits.

Question19: While the focus of data quality improvement efforts is often on the prevention of errors, data quality can also be improved through some forms of data processing.

Question20: When selecting a DMM framework one should consider of it is repeatable.

Question21: One of the deliverables in the Data Integration and Interoperability context diagram is:

Question22: Metadata is described using different set of categories, including:

Question23: Please select the 3 visuals that depict DAMA's Data Management Framework.

Question24: A node is a group of computers hosting either processing or data as part of a distributed database.

Question25: Access to data for Multidimensional databases use a variant of SQL called MDX or Multidimensional expression.

Question26: A hacker is a person who finds unknown operations and pathways within complex computer system. Hackers are only bad.

Question27: Communication should start later in the process as too many inputs will distort the vision.

Question28: The database administrator (DBA) is the most established and the most widely adopted data professional role.

Question29: Poorly managed Metadata leads to, among other, redundant data and data management processes.

Question30: The second stage of Kotter's eight stage process is:

Question31: Valuation information, as an example of data enrichment, is for asset valuation, inventory and sale.

Question32: A content strategy should end with an inventory of current state and a gap assessment.

Question33: Record management starts with a vague definition of what constitutes a record.

Question34: Data Governance is at the centre if the data management activities, since governance is required for consistency within and balance between functions.

Question35: The load step of the ETL is physically storing or presenting the results of the transformation into the source system.

Question36: SDLC stands for:

Question37: Change Data Capture is a method of reducing bandwidth by filtering to include only data that has been changed within a defined timeframe.

Question38: Data integrity is the state of being partitioned - protected from being whole.

Question39: Confirming and documenting understanding of different perspectives facilitate:

Question40: The Data Model Scorecard provides 10 data model quality metrics

Question41: SOA stand for Service Orchestrated Architecture

Question42: Data governance requires control mechanisms and procedures for, but not limited to, facilitating subjective discussions where managers' viewpoints are heard.

Question43: An input in the data architecture context diagram includes data governance.

Question44: Possible application coupling designs include:

Question45: Snowflaking is the term given to normalizing the flat, single-table, dimensional structure in a star schema into the respective component hierarchical or network structures.

Question46: A dimensional physical data model is usually a star schema, meaning there is one structure for each dimension.

Question47: One of the percentages to measure success of a records management system implantation is the percentage of the identified corporate records declared as such and put under records control.

Question48: A sandbox environment can either be a sub-set of the production system, walled off from production processing or a completely separate environment.

Question49: Effective document management requires clear policies and procedures, especially regarding retention and disposal of records.

Question50: Vulnerability is defined as:

Question51: Operational Metadata describes details of the processing and accessing of dat a. Which one is not an example:

Question52: Data science depends on:

Question53: The data in Data warehouses and marts differ. Data is organized by subject rather than function

Question54: An implemented warehouse and its customer-facing BI tools is a technology product.

Question55: Data security issues, breaches and unwarranted restrictions on employee access to data cannot directly impact operational success.

Question56: DAMA International's Certified Data Management Professional (CDMP) certification required that data management professionals subscribe to a formal code of ethics, including an obligation to handle data ethically for the sake of society beyond the organization that employs them.

Question57: To build models, data modellers heavily rely on previous analysis and modelling work.

Question58: Technical Metadata provides data about the technical data, the systems that store data, and the processes that move between systems.

Question59: Please select the user that best describes the following description: Uses the business glossary to make architecture, systems design, and development decisions, and to conduct the impact analysis.

Question60: ECM is an abbreviation for:

Question61: Activities that drive the goals in the context diagram are classified into the following phases:

Question62: Subtype absorption: The subtype entity attributes are included as nullable columns into a table representing the supertype entity

Question63: Changes to reference data do not need to be management, only metadata should be managed.

Question64: An implemented warehouse and its customer facing BI tool is a data product.

Question65: A 'Golden Record' means that it is always a 100% complete and accurate representation of all entities within the organization.

Question66: Those responsible for the data-sharing environment have an obligation to downstream data consumers to provide high quality data.

Question67: If the target system has more transformation capability than either the source or the intermediary application system, the order of processes may be switched to ELT - Extract Load Tranform.

Question68: Data governance requires control mechanisms and procedures for, but not limited to, escalating issues to higher level of authority.

Question69: The biggest business driver for developing organizational capabilities around Big Data and Data Science is the desire to find and act on business opportunities that may be discovered through data sets generated through a diversified range of processes.

Question70: DBAs and database architects combine their knowledge of available tools with the business requirements in order to suggest the best possible application of technology to meet organizational goals.

Question71: Traditional tool sin data visualtization have both a data and a graphical component. Advanced visualization and discovery tools use in-memory architecture to allow users to interact with the data.

Question72: Master data is an aggregation of:

Question73: Data Integration and Interoperability (DII) describes processes related to the movement and consolidation of data within and between data stores, applications and organizations.

Question74: In the context of big data the Three V's refer to: Volume, Velocity and Validity

Question75: The impact of the changes from new volatile data must be isolated from the bulk of the historical, non-volatile DW dat a. There are three main approaches, including:

Question76: Effectiveness metrics for a data governance programme includes: achievement of goals and objectives; extend stewards are using the relevant tools; effectiveness of communication; and effectiveness of education.

Question77: Veracity refers to how difficult the data is to use or to integrate.

Question78: A sandbox is an alternate environment that allows write-only connections to production data and can be managed by the administrator.

Question79: Factors that have shown to play a key role in the success in the success of effective data management organizations does not include:

Question80: Data Management Professionals only work with the technical aspects related to data.

Question81: The CAP theorem states that at most two of the three properties: consistency, availability and partition tolerance can exist in any shared data system.

Question82: The better an organization understands the lifecycle and lineage of its data, the better able it will be to manage its dat a. Please select correct implication of the focus of data management on the data lifecycle.

Question83: Self-service is a fundamental delivery channel in the BI portfolio.

Question84: Quality Assurance Testing (QA) is used to test functionality against requirements.

Question85: Big data primarily refers specifically to the volume of the data.

Question86: The purpose of data governance is to ensure that data is managed properly, according to policies and best practices. Data governance is focused on how decisions are made about data and how people and processes are expected to behave in relation to data.

Question87: A control activity in the metadata management environment includes loading statistical analysis.

Question88: A synonym for transformation in ETL is mapping. Mapping is the process of developing the lookup matrix from source to target structures, but not the result of the process.

Question89: Some common data quality business rule types are:

Question90: The most important reason to implement operational data quality measurements is to inform data consumers about levels of data effectiveness.

Question91: A communication plan includes an engagement model for stakeholders, the type of information to be shared, and the schedule for sharing information.

Question92: The first two steps in the data science process are:

Question93: On example of a transformation process in ETL is:

Question94: Within projects, conceptual data modelling and logical data modelling are part of requirements planning and analysis activities, while physical data modelling is a design activity.

Question95: Data stewardship is the least common label to describe accountability and responsibility for data and processes to ensure effective control and use of data assets.

Question96: XML provides a language for representing both structures and unstructured data and information.

Question97: SOA is an abbreviation for service orientated architecture.

Question98: Please select the correct definition of Data Management from the options below.

Question99: Improving an organization's ethical behaviour requires an informal Organizational Change Management (OCM) process.

Question100: An application DBA leads the review and administration of procedural database objects.

Question101: In a SQL injection attack, a perpetrator inserts authorized database statements into a vulnerable SQL data channel, such as a stored procedure.

Question102: The accuracy dimension has to do with the precision of data values.

Question103: Integration of ETL data flows will usually be developed within tools specialised to manage those flows in a proprietary way.

Question104: Please select the answer that does not represent a machine learning algorithm:

Question105: Please select the incorrect item that does not represent a dimension in the Data Values category in Data Quality for the Information age.

Question106: Data mining is a sub-field of supervised learning where users attempt to model data elements and predict future outcomes through the evaluation of probability estimates.

Question107: Data profiling is a form of data analysis used to inspect data and assess quality.

Question108: Data quality issues only emerge at initial stages of the data lifecycle.

Question109: Many people assume that most data quality issues are caused by data entry errors. A more sophisticated understanding recognizes that gaps in or execution of business and technical processes cause many more problems that mis-keying.

Question110: Data warehouses are often loaded and serviced by a nightly batch window.

Question111: Archiving is the process of moving data off immediately accessible storage media and onto media with lower retrieval performance.

Question112: Metadata is described using a different set of categories, not including:

Question113: Reference data management entails the preventative maintenance of undefined domain values, definitions and the relationship within and across domain values.

Question114: Data asset valuation is the process of understanding and calculating the economic value of data to an organisation. Value comes when the economic benefit of using data outweighs the costs of acquiring and storing it, as

Question115: Data security internal audits ensure data security and regulatory compliance policies are followed should be conducted regularly and consistently.

Question116: SLA Stands for:

Question117: A roadmap for enterprise data architecture describes the architecture's 3 to 5-year development path. The roadmap should be guided by a data management maturity assessment.